﻿using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient;

/// <summary>
/// Summary description for Apply
/// </summary>
public class Apply
{
    public int noid;
    public string address;
    public string phone;
    public float securityYearIncomeTotal;
    public float securityYearIncomeAvg;
    public float securityMonthIncomeAvg;
    public int securityNum;
    public int familyNum;
    public float propertyCurrentAssets;
    public float propertyFixedAssets;
    public float propertyDevice;
    public float propertyOther;
    public float hosingTotalArea;
    public float hosingTotalAreaAvg;
    public string docName;
    public string docNO;
    public DateTime docStopTime;
    public bool docIsContinue;
    public DateTime docContinueTime;
    public bool ssSubsidy;
    public float subsidyMoney;
    public float subsidyArea;
    public DateTime subsidyStartTime;
    public DateTime subsidyStopTime;
    public bool isReduce;
    public DateTime reducStartTime;
    public DateTime reducStopTime;
    public string reduceRenter;
    public string reduceAddress;
    public float reduceArea;
    public float reduceMonthRent;
    public float reduceMoney;
    public bool isProvidingRentHouses;
    public string providingRentHousesAddr;
    public float providingRentHousesErea;
    public float providingRentHousesEreaUsed;
    public DateTime providingRentHouseStartTime;
    public DateTime providingRentHouseStopTime;
    public DateTime publishTime;
    public bool publishCheck;
    public string publicCheckNoReason;
    public DateTime streetCheckTime;
    public string streetCheckHandlePerson;
    public string streetCheckChargePerson;
    public DateTime streetHousingOfficeCheckTime;
    public string streetHousingOfficeHandlePerson;
    public string streetHousingOfficeChargePerson;
    public DateTime civilBureauCheckTime;
    public string civilBureauHandlePerson;
    public string civilBureauChargePerson;
    public DateTime housingOfficeCheckTime;
    public string housingOfficeHandlePerson;
    public string housingOfficeChargePerson;
    public string longNoID;
    public int streetID;
    public int checkFlowStep;
    public int changeEventNO;
    public bool cardOrCash;
    public string cardID;
    public DateTime addTime;
    public DateTime editTime;

	public Apply()
	{
	}

    public bool AddApply(Apply apply)
    {
        SqlParameter[] par = new SqlParameter[61];
        par[0] = new SqlParameter("@NoID", DbType.Int32);
        par[0].Value = apply.noid;
        par[1] = new SqlParameter("@Address", DbType.String);
        par[1].Value = apply.address;
        par[2] = new SqlParameter("@Phone", DbType.String);
        par[2].Value = apply.phone;
        par[3] = new SqlParameter("@SecurityYearIncomeTotal", DbType.Double);
        par[3].Value = apply.securityYearIncomeTotal;
        par[4] = new SqlParameter("@SecurityYearIncomeAvg", DbType.Double);
        par[4].Value = apply.securityYearIncomeAvg;
        par[5] = new SqlParameter("@SecurityMonthIncomeAvg", DbType.Double);
        par[5].Value = apply.securityMonthIncomeAvg;
        par[6] = new SqlParameter("@SecurityNum", DbType.Int32);
        par[6].Value = apply.securityNum;
        par[7] = new SqlParameter("@FamilyNum", DbType.Int32);
        par[7].Value = apply.familyNum;
        par[8] = new SqlParameter("@PropertyCurrentAssets", DbType.Double);
        par[8].Value = apply.propertyCurrentAssets;
        par[9] = new SqlParameter("@PropertyFixedAssets", DbType.Double);
        par[9].Value = apply.propertyFixedAssets;
        par[10] = new SqlParameter("@PropertyDevice", DbType.Double);
        par[10].Value = apply.propertyDevice;
        par[11] = new SqlParameter("@PropertyOther", DbType.Double);
        par[11].Value = apply.propertyOther;
        par[12] = new SqlParameter("@HosingTotalArea", DbType.Double);
        par[12].Value = apply.hosingTotalArea;
        par[13] = new SqlParameter("@HosingTotalAreaAvg", DbType.Double);
        par[13].Value = apply.hosingTotalAreaAvg;
        par[14] = new SqlParameter("@DocName", DbType.String);
        par[14].Value = apply.docName;
        par[15] = new SqlParameter("@DocNO", DbType.String);
        par[15].Value = apply.docNO;
        par[16] = new SqlParameter("@DocStopTime", DbType.DateTime);
        par[16].Value = apply.docStopTime;
        par[17] = new SqlParameter("@DocIsContinue", DbType.Boolean);
        par[17].Value = apply.docIsContinue;
        par[18] = new SqlParameter("@DocContinueTime", DbType.DateTime);
        par[18].Value = apply.docContinueTime;
        par[19] = new SqlParameter("@IsSubsidy", DbType.Boolean);
        par[19].Value = apply;
        par[20] = new SqlParameter("@SubsidyMoney", DbType.Double);
        par[20].Value = apply;
        par[21] = new SqlParameter("@SubsidyArea", DbType.Double);
        par[21].Value = apply;
        par[22] = new SqlParameter("@SubsidyStartTime", DbType.DateTime);
        par[22].Value = apply;
        par[23] = new SqlParameter("@SubsidyStopTime", DbType.DateTime);
        par[23].Value = apply;
        par[24] = new SqlParameter("@IsReduce", DbType.Boolean);
        par[24].Value = apply;
        par[25] = new SqlParameter("@ReducStartTime", DbType.DateTime);
        par[25].Value = apply;
        par[26] = new SqlParameter("@ReducStopTime", DbType.DateTime);
        par[26].Value = apply;
        par[27] = new SqlParameter("@ReduceRenter", DbType.String);
        par[27].Value = apply;
        par[28] = new SqlParameter("@ReduceAddress", DbType.String);
        par[28].Value = apply;
        par[29] = new SqlParameter("@ReduceArea", DbType.Double);
        par[29].Value = apply;
        par[30] = new SqlParameter("@ReduceMonthRent", DbType.Double);
        par[30].Value = apply;
        par[31] = new SqlParameter("@ReduceMoney", DbType.Double);
        par[31].Value = apply;
        par[32] = new SqlParameter("@IsProvidingRentHouses", DbType.Boolean);
        par[32].Value = apply;
        par[33] = new SqlParameter("@ProvidingRentHousesAddr", DbType.String);
        par[33].Value = apply;
        par[34] = new SqlParameter("@ProvidingRentHousesErea", DbType.Double);
        par[34].Value = apply;
        par[35] = new SqlParameter("@ProvidingRentHousesEreaUsed", DbType.Double);
        par[35].Value = apply;
        par[36] = new SqlParameter("@ProvidingRentHouseStartTime", DbType.DateTime);
        par[36].Value = apply;
        par[37] = new SqlParameter("@ProvidingRentHouseStopTime", DbType.DateTime);
        par[37].Value = apply;
        par[38] = new SqlParameter("@PublishTime", DbType.DateTime);
        par[38].Value = apply;
        par[39] = new SqlParameter("@publishCheck", DbType.Boolean);
        par[39].Value = apply;
        par[40] = new SqlParameter("@PublicCheckNoReason", DbType.String);
        par[40].Value = apply;
        par[41] = new SqlParameter("@StreetCheckTime", DbType.DateTime);
        par[41].Value = apply;
        par[42] = new SqlParameter("@StreetCheckHandlePerson", DbType.String);
        par[42].Value = apply;
        par[43] = new SqlParameter("@StreetCheckChargePerson", DbType.String);
        par[43].Value = apply;
        par[44] = new SqlParameter("@StreetHousingOfficeCheckTime", DbType.DateTime);
        par[44].Value = apply;
        par[45] = new SqlParameter("@StreetHousingOfficeHandlePerson", DbType.String);
        par[45].Value = apply;
        par[46] = new SqlParameter("@StreetHousingOfficeChargePerson", DbType.String);
        par[46].Value = apply;
        par[47] = new SqlParameter("@CivilBureauCheckTime", DbType.DateTime);
        par[47].Value = apply;
        par[48] = new SqlParameter("@CivilBureauHandlePerson", DbType.String);
        par[48].Value = apply;
        par[49] = new SqlParameter("@CivilBureauChargePerson", DbType.String);
        par[49].Value = apply;
        par[50] = new SqlParameter("@HousingOfficeCheckTime", DbType.DateTime);
        par[50].Value = apply;
        par[51] = new SqlParameter("@HousingOfficeHandlePerson", DbType.String);
        par[51].Value = apply;
        par[52] = new SqlParameter("@HousingOfficeChargePerson", DbType.String);
        par[52].Value = apply;
        par[53] = new SqlParameter("@LongNoID", DbType.String);
        par[53].Value = apply;
        par[54] = new SqlParameter("@StreetID", DbType.Int32);
        par[54].Value = apply;
        par[55] = new SqlParameter("@CheckFlowStep", DbType.Int32);
        par[55].Value = apply;
        par[56] = new SqlParameter("@ChangeEventNO", DbType.Int32);
        par[56].Value = apply;
        par[57] = new SqlParameter("@CardOrCash", DbType.Boolean);
        par[57].Value = apply;
        par[58] = new SqlParameter("@CardID", DbType.String);
        par[58].Value = apply;
        par[59] = new SqlParameter("@AddTime", DbType.DateTime);
        par[59].Value = apply;
        par[60] = new SqlParameter("@EditTime", DbType.DateTime);
        par[60].Value = apply;


    }
}
